/ The Macintosh Demo: Business Productivity / The Macintosh Demo Applications CD - Business Productivity (Apple Computer)(1993).iso / Spreadsheets⁄Databases / SpreadBase® / Learning SpreadBase® / Formulas in SpreadBase

< prev

next >

MacOS 8.1

Win98

DOS

browse contents

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 16 46 6f 72 6d 75 6c | 61 73 20 69 6e 20 53 70 |..Formul|as in Sp|
|00000010| 72 65 61 64 42 61 73 65 | 00 00 00 00 00 00 00 00 |readBase|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 53 52 53 50 53 52 50 | 4c 01 00 00 00 00 00 00 |.SRSPSRP|L.......|
|00000050| 00 00 00 00 00 00 01 00 | 00 12 48 a7 31 ba fc a7 |........|..H.1...|
|00000060| 31 ba fd 00 00 02 00 00 | 00 00 00 00 00 00 00 00 |1.......|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 81 81 75 96 00 00 |........|....u...|
|00000080| 01 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 01 00 00 00 11 86 | 00 00 10 86 00 00 00 c2 |........|........|
|00000110| 00 02 00 03 01 01 00 00 | 00 00 00 10 00 08 00 00 |........|........|
|00000120| 00 00 00 06 00 00 00 42 | 01 76 02 1f 01 88 02 49 |.......B|.v.....I|
|00000130| 16 46 6f 72 6d 75 6c 61 | 73 20 69 6e 20 53 70 72 |.Formula|s in Spr|
|00000140| 65 61 64 42 61 73 65 20 | 02 00 00 00 53 52 53 50 |eadBase |....SRSP|
|00000150| 00 00 53 52 53 50 53 52 | 50 4c 01 02 00 df 00 c3 |..SRSPSR|PL......|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 a7 31 ba fc 00 00 | 00 01 00 00 12 48 00 42 |...1....|.....H.B|
|00000180| 01 5c 02 1f 01 6e 02 79 | 00 03 ff ff ff ff ff ff |.\...n.y|........|
|00000190| 00 01 01 76 0b 50 61 75 | 73 65 2f 43 6f 6e 74 2e |...v.Pau|se/Cont.|
|000001a0| 1a 1a 00 00 07 b8 00 34 | 38 0e 00 00 e0 f8 00 01 |.......4|8.......|
|000001b0| 1f e8 40 80 20 04 b6 00 | 00 03 01 01 00 00 00 00 |..@. ...|........|
|000001c0| 00 10 00 08 00 00 00 00 | 00 01 00 00 00 24 01 43 |........|.....$.C|
|000001d0| 02 1b 01 54 02 7e 00 02 | 02 41 ab 54 ea ff 00 01 |...T.~..|.A.T....|
|000001e0| 01 76 12 8c 01 00 00 0a | 00 00 00 00 00 00 00 01 |.v......|........|
|000001f0| 01 72 00 08 00 00 00 09 | 31 30 61 20 6f 66 20 32 |.r......|10a of 2|
|00000200| 00 00 00 78 00 03 00 00 | 00 48 00 48 00 00 00 00 |...x....|.H.H....|
|00000210| 02 da 02 28 ff e1 ff e2 | 02 f9 02 46 03 47 05 28 |...(....|...F.G.(|
|00000220| 03 fc 00 02 00 00 00 48 | 00 48 00 00 00 00 02 da |.......H|.H......|
|00000230| 02 28 00 01 00 00 00 64 | 00 00 00 01 00 01 01 01 |.(.....d|........|
|00000240| 00 00 00 01 27 0f 00 01 | 00 01 00 00 00 00 00 00 |....'...|........|
|00000250| 00 00 00 00 00 00 00 02 | 00 19 01 90 00 00 00 00 |........|........|
|00000260| 00 40 00 00 00 00 00 00 | 00 00 00 01 00 00 00 00 |.@......|........|
|00000270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 2a |........|.......*|
|00000280| 00 0b 00 02 00 a6 00 21 | 01 69 02 61 00 00 00 00 |.......!|.i.a....|
|00000290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|000002a0| 00 00 02 80 01 e0 02 00 | 00 00 00 00 02 04 4d a5 |........|......M.|
|000002b0| 00 00 00 00 00 00 00 00 | 0a 50 31 20 46 6f 6d 75 |........|.P1 Fomu|
|000002c0| 6c 61 73 5c 00 45 66 5c | 00 00 00 00 00 00 00 00 |las\.Ef\|........|
|000002d0| 00 00 00 00 00 73 b3 2e | 00 72 00 00 00 01 00 00 |.....s..|.r......|
|000002e0| 00 00 00 00 00 00 01 41 | 00 00 01 00 00 00 00 00 |.......A|........|
|000002f0| 00 01 02 00 00 00 00 00 | 00 c1 00 00 00 ff ff 00 |........|........|
|00000300| 00 00 00 ff ff ff 00 00 | ff ff 00 00 00 00 00 00 |........|........|
|00000310| 00 00 00 00 00 00 00 00 | 00 00 00 00 41 4c 52 54 |........|....ALRT|
|00000320| 7f ff ff ff fc 00 00 00 | 40 00 00 00 0c 00 00 00 |........|@.......|
|00000330| 47 ff 6f ff 8c 00 00 00 | 47 ff 6f ff 8c 00 00 00 |G.o.....|G.o.....|
|00000340| 40 00 04 00 0c 00 00 00 | 7f ff ff ff fc 00 00 00 |@.......|........|
|00000350| 7f ff ff ff ff ff ff f0 | 3f ff ff ff ff ff ff e0 |........|?.......|
|00000360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000370| 03 ff bd ff 5f f0 00 00 | 01 91 39 3f 5b f0 00 00 |...._...|..9?[...|
|00000380| 00 00 00 00 00 00 00 00 | 01 ff ff f8 00 00 00 00 |........|........|
|00000390| 01 ef fe 08 00 00 00 00 | 01 ff ff f8 00 00 00 00 |........|........|
|000003a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003b0| 00 ff f7 ff ef 80 00 00 | 00 ce 36 f1 28 00 00 00 |........|..6.(...|
|000003c0| 00 ff bf ef ff f8 00 00 | 00 fd 78 00 00 00 00 00 |........|..x.....|
|000003d0| 00 fd 7c 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |..|.....|........|
|000003e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003f0| 01 ff ff f0 00 00 00 00 | 01 fd ff d0 00 00 00 00 |........|........|
|00000400| 01 ff ff f0 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000410| 00 00 00 00 00 00 03 ff | 01 ff ff fe ff f7 c7 ff |........|........|
|00000420| 00 14 00 00 40 01 87 ff | 01 ef ff ff 7f ff 87 ff |....@...|........|
|00000430| 01 ff f7 57 bf e7 c7 ff | 00 fb 57 d6 b3 f6 46 fd |...W....|..W...F.|
|00000440| 01 df ef ff ff e0 07 ff | 00 f9 dd ad 00 00 07 ff |........|........|
|00000450| 01 ff ff bf 80 00 07 ff | 00 00 00 00 00 00 03 ff |........|........|
|00000460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004a0| 00 00 00 00 00 00 00 a0 | 00 00 00 00 00 00 00 00 |........|........|
|000004b0| 00 01 00 00 05 42 00 01 | 00 00 00 24 00 63 00 3a |.....B..|...$.c.:|
|000004c0| 00 7e 01 d6 00 02 ff ff | ff ff ff ff 00 04 01 33 |.~......|.......3|
|000004d0| 00 03 01 00 00 0e 00 00 | 00 00 00 00 00 00 00 a0 |........|........|
|000004e0| 00 08 00 00 00 2e 54 68 | 65 72 65 20 61 72 65 20 |......Th|ere are |
|000004f0| 74 77 6f 20 74 79 70 65 | 73 20 6f 66 20 66 6f 72 |two type|s of for|
|00000500| 6d 75 6c 61 73 20 69 6e | 20 53 70 72 65 61 64 42 |mulas in| SpreadB|
|00000510| 61 73 65 3a 00 02 00 00 | 00 24 00 3e 00 0e 00 40 |ase:....|.$.>...@|
|00000520| 02 56 00 03 00 00 00 00 | 00 00 00 02 01 5d 00 3f |.V......|.....].?|
|00000530| 02 55 00 3f 00 0f 00 0a | 00 04 00 00 00 33 00 02 |.U.?....|.....3..|
|00000540| 00 00 00 24 00 43 00 0d | 00 47 02 57 00 03 00 00 |...$.C..|.G.W....|
|00000550| 00 00 00 00 00 03 01 5d | 00 45 02 55 00 45 00 0f |.......]|.E.U.E..|
|00000560| 00 0a 00 04 00 00 00 33 | 00 01 00 00 00 24 00 05 |.......3|.....$..|
|00000570| 00 0e 00 38 01 75 00 02 | dd 6b 08 c2 06 a2 00 02 |...8.u..|.k......|
|00000580| 01 0d 00 03 01 00 00 0e | 00 00 00 00 00 00 00 00 |........|........|
|00000590| 02 5d 00 08 00 00 00 00 | 00 01 00 00 00 24 00 08 |.]......|.....$..|
|000005a0| 00 12 00 34 01 71 00 02 | ff ff ff ff ff ff 00 02 |...4.q..|........|
|000005b0| 01 62 00 03 01 00 00 0e | 00 00 00 00 00 00 00 00 |.b......|........|
|000005c0| 01 5d 00 08 00 00 00 00 | 00 01 00 00 00 24 00 14 |.]......|.....$..|
|000005d0| 00 1c 00 29 01 66 00 02 | ff ff ff ff ff ff 00 04 |...).f..|........|
|000005e0| 01 62 00 14 01 00 00 18 | 00 00 00 00 00 00 00 01 |.b......|........|
|000005f0| 00 5d 00 08 00 00 00 16 | 46 6f 72 6d 75 6c 61 73 |.]......|Formulas|
|00000600| 20 69 6e 20 53 70 72 65 | 61 64 42 61 73 65 00 01 | in Spre|adBase..|
|00000610| 00 00 00 24 00 b4 00 4d | 00 eb 01 e2 00 02 ff ff |...$...M|........|
|00000620| ff ff ff ff 00 02 01 62 | 00 03 01 00 00 0c 00 00 |.......b|........|
|00000630| 00 00 00 00 00 00 00 5d | 00 08 00 00 00 75 53 70 |.......]|.....uSp|
|00000640| 72 65 61 64 73 68 65 65 | 74 2d 6c 69 6b 65 20 63 |readshee|t-like c|
|00000650| 65 6c 6c 2d 62 61 73 65 | 64 20 66 6f 72 6d 75 6c |ell-base|d formul|
|00000660| 61 73 20 73 75 63 68 20 | 61 73 20 22 3d 42 34 2b |as such |as "=B4+|
|00000670| 41 31 34 22 20 6f 72 20 | 22 3d 53 55 4d 28 42 31 |A14" or |"=SUM(B1|
|00000680| 3a 42 35 29 22 20 61 72 | 65 20 62 61 73 65 64 20 |:B5)" ar|e based |
|00000690| 6f 6e 20 63 6f 6f 72 64 | 69 6e 61 74 65 20 6c 6f |on coord|inate lo|
|000006a0| 63 61 74 69 6f 6e 73 20 | 69 6e 20 61 20 76 69 65 |cations |in a vie|
|000006b0| 77 2e 20 00 00 01 00 00 | 00 24 01 06 00 49 01 20 |w. .....|.$...I. |
|000006c0| 01 16 00 02 ff ff ff ff | ff ff 00 02 01 62 00 03 |........|.....b..|
|000006d0| 01 00 00 0c 00 00 00 00 | 00 00 00 00 02 5d 00 08 |........|.....]..|
|000006e0| 00 00 00 17 43 61 74 65 | 67 6f 72 79 2d 62 61 73 |....Cate|gory-bas|
|000006f0| 65 64 20 46 6f 72 6d 75 | 6c 61 73 00 00 01 00 00 |ed Formu|las.....|
|00000700| 00 24 00 83 00 4d 00 9d | 01 1a 00 02 ff ff ff ff |.$...M..|........|
|00000710| ff ff 00 02 01 62 00 03 | 01 00 00 0c 00 00 00 00 |.....b..|........|
|00000720| 00 00 00 00 02 5d 00 08 | 00 00 00 13 43 65 6c 6c |.....]..|....Cell|
|00000730| 2d 62 61 73 65 64 20 46 | 6f 72 6d 75 6c 61 73 00 |-based F|ormulas.|
|00000740| 00 01 00 00 00 24 01 35 | 00 4a 01 89 01 fe 00 02 |.....$.5|.J......|
|00000750| ff ff ff ff ff ff 00 02 | 01 62 00 03 01 00 00 0c |........|.b......|
|00000760| 00 00 00 00 00 00 00 00 | 00 5d 00 08 00 00 01 05 |........|.]......|
|00000770| 43 61 74 65 67 6f 72 79 | 2d 62 61 73 65 64 20 66 |Category|-based f|
|00000780| 6f 72 6d 75 6c 61 73 20 | 73 75 63 68 20 61 73 20 |ormulas |such as |
|00000790| 22 56 61 72 69 61 6e 63 | 65 3d 41 63 74 75 61 6c |"Varianc|e=Actual|
|000007a0| 2d 42 75 64 67 65 74 22 | 20 72 65 66 65 72 20 74 |-Budget"| refer t|
|000007b0| 6f 20 64 61 74 61 20 69 | 6e 20 6c 6f 67 69 63 61 |o data i|n logica|
|000007c0| 6c 20 67 72 6f 75 70 69 | 6e 67 73 2e 20 20 59 6f |l groupi|ngs.  Yo|
|000007d0| 75 20 63 61 6e 20 77 72 | 69 74 65 20 61 20 73 69 |u can wr|ite a si|
|000007e0| 6e 67 6c 65 20 66 6f 72 | 6d 75 6c 61 20 74 68 61 |ngle for|mula tha|
|000007f0| 74 20 77 69 6c 6c 20 61 | 70 70 6c 79 20 74 6f 20 |t will a|pply to |
|00000800| 61 6e 20 65 6e 74 69 72 | 65 20 63 65 6c 6c 20 63 |an entir|e cell c|
|00000810| 61 74 65 67 6f 72 79 2e | 20 20 52 65 76 69 65 77 |ategory.|  Review|
|00000820| 20 74 68 65 20 22 53 70 | 6c 69 74 74 69 6e 67 20 | the "Sp|litting |
|00000830| 43 65 6c 6c 73 22 20 73 | 65 63 74 69 6f 6e 20 6f |Cells" s|ection o|
|00000840| 66 20 74 68 69 73 20 64 | 65 6d 6f 20 74 6f 20 73 |f this d|emo to s|
|00000850| 65 65 20 63 61 74 65 67 | 6f 72 79 2d 62 61 73 65 |ee categ|ory-base|
|00000860| 64 20 66 6f 72 6d 75 6c | 61 73 20 69 6e 20 61 63 |d formul|as in ac|
|00000870| 74 69 6f 6e 2e 00 00 03 | 00 00 00 14 01 53 02 1b |tion....|.....S..|
|00000880| 01 8f 02 7e 00 03 02 41 | ab 54 ea ff 00 01 01 5d |...~...A|.T.....]|
|00000890| 00 06 00 00 00 42 01 5c | 02 1f 01 6e 02 79 00 03 |.....B.\|...n.y..|
|000008a0| ff ff ff ff ff ff 00 01 | 01 1b 08 43 6f 6e 74 69 |........|...Conti|
|000008b0| 6e 75 65 6e 74 2e 1a 1a | 00 00 07 b8 00 34 38 0e |nuent...|.....48.|
|000008c0| 00 00 e0 f8 00 01 1f e8 | 40 80 20 04 00 00 00 03 |........|@. .....|
|000008d0| 01 01 00 00 00 00 00 10 | 00 08 00 00 00 00 00 06 |........|........|
|000008e0| 00 00 00 42 01 76 02 4f | 01 88 02 79 00 03 ff ff |...B.v.O|...y....|
|000008f0| ff ff ff ff 00 01 01 62 | 04 51 75 69 74 77 61 72 |.......b|.Quitwar|
|00000900| 64 73 6e 81 1a 1a 00 00 | 07 b8 00 34 38 0e 00 00 |dsn.....|...48...|
|00000910| e0 f8 00 01 1f e8 40 80 | 20 04 00 02 00 03 01 01 |......@.| .......|
|00000920| 00 00 00 00 00 10 00 08 | 00 00 00 00 00 06 00 00 |........|........|
|00000930| 00 42 01 76 02 1f 01 88 | 02 49 00 03 ff ff ff ff |.B.v....|.I......|
|00000940| ff ff 00 01 01 62 04 4d | 65 6e 75 74 20 45 6e 64 |.....b.M|enut End|
|00000950| 61 73 65 20 54 72 61 69 | 6e 69 6e 67 ec 40 00 75 |ase Trai|ning.@.u|
|00000960| e1 02 00 37 e6 70 00 75 | 00 09 00 03 01 01 2f 06 |...7.p.u|....../.|
|00000970| 00 00 00 10 00 08 00 00 | 00 0a 3a 46 72 6f 6e 74 |........|..:Front|
|00000980| 20 45 6e 64 00 01 00 00 | 00 24 01 43 02 1b 01 54 | End....|.$.C...T|
|00000990| 02 7e 00 02 02 41 ab 54 | ea ff 00 01 01 62 00 14 |.~...A.T|.....b..|
|000009a0| 01 00 00 0a 00 00 00 00 | 00 00 00 01 01 5d 00 08 |........|.....]..|
|000009b0| 00 00 00 06 31 20 6f 66 | 20 32 00 01 00 00 00 24 |....1 of| 2.....$|
|000009c0| 01 31 02 1b 01 44 02 7e | 00 02 02 41 ab 54 ea ff |.1...D.~|...A.T..|
|000009d0| 00 01 01 62 00 14 01 00 | 00 0a 00 00 00 00 00 00 |...b....|........|
|000009e0| 00 01 01 5d 00 08 00 00 | 00 08 46 6f 72 6d 75 6c |...]....|..Formul|
|000009f0| 61 73 00 00 00 00 00 00 | 00 00 02 04 41 11 00 00 |as......|....A...|
|00000a00| 00 00 00 00 00 00 0a 50 | 32 20 46 6f 6d 75 6c 61 |.......P|2 Fomula|
|00000a10| 73 07 ff 00 00 00 fc c0 | 00 20 84 00 00 00 00 00 |s.......|. ......|
|00000a20| 01 e0 02 80 00 00 00 00 | 00 00 00 01 00 00 00 00 |........|........|
|00000a30| 00 00 00 00 01 00 00 00 | 01 00 00 00 00 00 00 01 |........|........|
|00000a40| 27 04 00 00 00 00 00 c1 | 13 43 65 6c 6c 2d 62 61 |'.......|.Cell-ba|
|00000a50| 73 65 64 20 46 6f 72 6d | 75 6c 61 73 15 6e 00 00 |sed Form|ulas.n..|
|00000a60| 01 00 00 05 00 76 da e8 | 00 00 00 00 00 00 00 00 |.....v..|........|
|00000a70| 00 00 00 00 00 00 70 00 | 08 00 00 00 00 00 7f ef |......p.|........|
|00000a80| af fe 00 00 00 00 7f ef | eb fe 00 00 00 00 78 00 |........|......x.|
|00000a90| 00 00 00 00 00 00 7f ff | ff ff ff ff ff f0 3f ff |........|......?.|
|00000aa0| ff ff ff ff ff f0 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 03 ff |........|........|
|00000ac0| ff ff ff bf e0 00 00 09 | 00 00 00 20 00 00 03 ff |........|... ....|
|00000ad0| ff fc 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ae0| 00 00 00 00 00 00 07 ff | ff e0 00 00 00 00 07 ff |........|........|
|00000af0| c0 20 00 00 00 00 03 ff | ff e0 00 00 00 00 00 00 |. ......|........|
|00000b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 03 ff |........|........|
|00000b10| ff eb 7f f0 00 00 02 08 | 00 80 40 00 00 00 03 ff |........|..@.....|
|00000b20| ff ff fe fc 00 00 03 77 | fd f8 00 00 00 00 01 07 |.......w|........|
|00000b30| 2c 48 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |,H......|........|
|00000b40| 00 00 00 00 00 00 03 ff | ff e0 00 00 00 00 07 ff |........|........|
|00000b50| f8 20 00 00 00 00 04 00 | 00 20 00 00 00 00 03 ff |. ......|. ......|
|00000b60| ff e0 00 00 03 ff 00 00 | 00 00 00 00 07 ff 03 ff |........|........|
|00000b70| ff ff ff ff 87 ff 03 7e | fe ff 7d ee 07 ff 03 5f |.......~|..}...._|
|00000b80| fe fb 6d 6f 07 ff 01 ff | 7f ff fe f5 87 fd 02 04 |..mo....|........|
|00000b90| 00 81 90 00 07 ff 03 df | ff ff ff f8 07 ff 03 f0 |........|........|
|00000ba0| 00 00 00 00 07 ff 00 40 | 00 00 00 00 03 ff 00 00 |.......@|........|
|00000bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bf0| 00 00 00 00 00 fd 00 00 | 00 00 00 00 00 00 ff 01 |........|........|
|00000c00| 00 00 06 1e 00 01 00 00 | 00 24 00 61 00 3a 00 89 |........|.$.a.:..|
|00000c10| 01 f9 00 02 ff ff ff ff | ff ff 00 04 01 00 00 03 |........|........|
|00000c20| 01 00 00 0e 00 00 00 00 | 00 00 00 00 00 45 00 08 |........|.....E..|
|00000c30| 00 00 00 51 46 6f 72 6d | 75 6c 61 73 20 63 61 6e |...QForm|ulas can|
|00000c40| 20 65 69 74 68 65 72 20 | 62 65 20 63 72 65 61 74 | either |be creat|
|00000c50| 65 64 20 6d 61 6e 75 61 | 6c 6c 79 20 6f 72 20 67 |ed manua|lly or g|
|00000c60| 65 6e 65 72 61 74 65 64 | 20 61 75 74 6f 6d 61 74 |enerated| automat|
|00000c70| 69 63 61 6c 6c 79 20 62 | 79 20 53 70 72 65 61 64 |ically b|y Spread|
|00000c80| 42 61 73 65 3a 00 00 01 | 00 00 00 24 00 c6 00 3b |Base:...|...$...;|
|00000c90| 00 fd 01 d0 00 02 ff ff | ff ff ff ff 00 02 01 47 |........|.......G|
|00000ca0| 00 03 01 00 00 0c 00 00 | 00 00 00 00 00 00 00 42 |........|.......B|
|00000cb0| 00 08 00 00 00 8b 4d 61 | 6e 75 61 6c 20 66 6f 72 |......Ma|nual for|
|00000cc0| 6d 75 6c 61 73 20 66 6f | 6c 6c 6f 77 20 73 70 72 |mulas fo|llow spr|
|00000cd0| 65 61 64 73 68 65 65 74 | 2d 6c 69 6b 65 20 70 72 |eadsheet|-like pr|
|00000ce0| 6f 63 65 64 75 72 65 73 | 2e 20 20 4d 6f 76 65 20 |ocedures|.  Move |
|00000cf0| 74 6f 20 74 68 65 20 6e | 65 78 74 20 73 65 63 74 |to the n|ext sect|
|00000d00| 69 6f 6e 20 22 43 65 6c | 6c 2d 62 61 73 65 64 20 |ion "Cel|l-based |
|00000d10| 46 6f 72 6d 75 6c 61 73 | 22 20 74 6f 20 66 69 6e |Formulas|" to fin|
|00000d20| 64 20 6f 75 74 20 6d 6f | 72 65 20 61 62 6f 75 74 |d out mo|re about|
|00000d30| 20 6d 61 6e 75 61 6c 20 | 66 6f 72 6d 75 6c 61 73 | manual |formulas|
|00000d40| 2e 00 00 01 00 00 00 24 | 01 13 00 3b 01 2d 01 08 |.......$|...;.-..|
|00000d50| 00 02 ff ff ff ff ff ff | 00 02 01 47 00 03 01 00 |........|...G....|
|00000d60| 00 0c 00 00 00 00 00 00 | 00 00 02 42 00 08 00 00 |........|...B....|
|00000d70| 00 12 41 75 74 6f 6d 61 | 74 69 63 20 46 6f 72 6d |..Automa|tic Form|
|00000d80| 75 6c 61 73 00 01 00 00 | 00 24 00 96 00 3b 00 b0 |ulas....|.$...;..|
|00000d90| 01 08 00 02 ff ff ff ff | ff ff 00 02 01 47 00 03 |........|.....G..|
|00000da0| 01 00 00 0c 00 00 00 00 | 00 00 00 00 02 42 00 08 |........|.....B..|
|00000db0| 00 00 00 0f 4d 61 6e 75 | 61 6c 20 46 6f 72 6d 75 |....Manu|al Formu|
|00000dc0| 6c 61 73 00 00 01 00 00 | 00 24 01 3c 00 3a 01 90 |las.....|.$.<.:..|
|00000dd0| 01 ee 00 02 ff ff ff ff | ff ff 00 02 01 47 00 03 |........|.....G..|
|00000de0| 01 00 00 0c 00 00 00 00 | 00 00 00 00 00 42 00 08 |........|.....B..|
|00000df0| 00 00 00 ee 59 6f 75 27 | 6c 6c 20 73 65 65 20 61 |....You'|ll see a|
|00000e00| 6e 20 65 78 61 6d 70 6c | 65 20 6f 66 20 61 20 4d |n exampl|e of a M|
|00000e10| 61 74 72 69 78 20 76 69 | 65 77 20 61 75 74 6f 6d |atrix vi|ew autom|
|00000e20| 61 74 69 63 20 66 6f 72 | 6d 75 6c 61 20 69 6e 20 |atic for|mula in |
|00000e30| 74 68 65 20 22 43 72 65 | 61 74 69 6e 67 20 41 75 |the "Cre|ating Au|
|00000e40| 74 6f 6d 61 74 69 63 20 | 53 75 6d 6d 61 72 69 65 |tomatic |Summarie|
|00000e50| 73 22 20 73 65 63 74 69 | 6f 6e 20 6f 66 20 74 68 |s" secti|on of th|
|00000e60| 69 73 20 64 65 6d 6f 2e | 20 20 52 65 66 65 72 20 |is demo.|  Refer |
|00000e70| 74 6f 20 74 68 65 20 73 | 6f 72 74 69 6e 67 20 61 |to the s|orting a|
|00000e80| 6e 64 20 73 75 6d 6d 61 | 72 69 7a 69 6e 67 20 73 |nd summa|rizing s|
|00000e90| 65 67 6d 65 6e 74 20 69 | 6e 20 74 68 65 20 22 54 |egment i|n the "T|
|00000ea0| 61 62 6c 65 20 56 69 65 | 77 22 20 73 65 63 74 69 |able Vie|w" secti|
|00000eb0| 6f 6e 20 74 6f 20 73 65 | 65 20 61 6e 6f 74 68 65 |on to se|e anothe|
|00000ec0| 72 20 65 78 61 6d 70 6c | 65 20 6f 66 20 61 6e 20 |r exampl|e of an |
|00000ed0| 61 75 74 6f 6d 61 74 69 | 63 20 66 6f 72 6d 75 6c |automati|c formul|
|00000ee0| 61 2e 00 02 00 00 00 24 | 00 34 00 0f 00 36 02 57 |a......$|.4...6.W|
|00000ef0| 00 03 00 00 00 00 00 00 | 00 02 01 42 00 35 02 56 |........|...B.5.V|
|00000f00| 00 35 00 10 00 0a 00 04 | 00 00 00 18 00 02 00 00 |.5......|........|
|00000f10| 00 24 00 39 00 0e 00 3d | 02 58 00 03 00 00 00 00 |.$.9...=|.X......|
|00000f20| 00 00 00 03 01 42 00 3b | 02 56 00 3b 00 10 00 0a |.....B.;|.V.;....|
|00000f30| 00 04 00 00 00 18 00 01 | 00 00 00 24 00 10 00 35 |........|...$...5|
|00000f40| 00 2b 02 32 00 02 ff ff | ff ff ff ff 00 04 01 0e |.+.2....|........|
|00000f50| 00 14 01 00 00 18 00 00 | 00 00 00 00 00 00 00 42 |........|.......B|
|00000f60| 00 08 00 00 00 13 4d 6f | 72 65 20 41 62 6f 75 74 |......Mo|re About|
|00000f70| 20 46 6f 72 6d 75 6c 61 | 73 00 00 01 00 00 00 24 | Formula|s......$|
|00000f80| 00 0e 00 0f 00 29 00 2f | 00 02 dd 6b 08 c2 06 a2 |.....)./|...k....|
|00000f90| 00 02 01 47 00 03 01 00 | 00 0e 00 00 00 00 00 00 |...G....|........|
|00000fa0| 00 00 02 42 00 08 00 00 | 00 00 00 03 00 00 00 14 |...B....|........|
|00000fb0| 01 53 02 1b 01 8f 02 7e | 00 03 02 41 ab 54 ea ff |.S.....~|...A.T..|
|00000fc0| 00 01 01 42 00 06 00 00 | 00 42 01 76 02 4f 01 88 |...B....|.B.v.O..|
|00000fd0| 02 79 00 03 ff ff ff ff | ff ff 00 01 01 1b 04 51 |.y......|.......Q|
|00000fe0| 75 69 74 77 61 72 64 73 | 6e 81 1a 1a 00 00 07 b8 |uitwards|n.......|
|00000ff0| 00 34 38 0e 00 00 e0 f8 | 00 01 1f e8 40 80 20 04 |.48.....|....@. .|
|00001000| 00 02 00 03 01 01 00 00 | 00 00 00 10 00 08 00 00 |........|........|
|00001010| 00 00 00 06 00 00 00 42 | 01 76 02 1f 01 88 02 49 |.......B|.v.....I|
|00001020| 00 03 ff ff ff ff ff ff | 00 01 01 47 04 4d 65 6e |........|...G.Men|
|00001030| 75 74 20 45 6e 64 61 73 | 65 20 54 72 61 69 6e 69 |ut Endas|e Traini|
|00001040| 6e 67 ec 40 00 75 e1 02 | 00 37 e6 70 00 75 00 09 |ng.@.u..|.7.p.u..|
|00001050| 00 03 01 01 2f 06 00 00 | 00 10 00 08 00 00 00 0a |..../...|........|
|00001060| 3a 46 72 6f 6e 74 20 45 | 6e 64 00 01 00 00 00 24 |:Front E|nd.....$|
|00001070| 01 43 02 1b 01 54 02 7e | 00 02 02 41 ab 54 ea ff |.C...T.~|...A.T..|
|00001080| 00 01 01 47 00 14 01 00 | 00 0a 00 00 00 00 00 00 |...G....|........|
|00001090| 00 01 01 42 00 08 00 00 | 00 06 32 20 6f 66 20 32 |...B....|..2 of 2|
|000010a0| 00 06 00 00 00 42 01 5c | 02 4f 01 6e 02 79 00 03 |.....B.\|.O.n.y..|
|000010b0| ff ff ff ff ff ff 00 01 | 01 47 08 63 6f 6e 74 69 |........|.G.conti|
|000010c0| 6e 75 65 73 6e 81 1a 1a | 00 00 07 b8 00 34 38 0e |nuesn...|.....48.|
|000010d0| 00 00 e0 f8 00 01 1f e8 | 40 80 20 04 00 00 00 03 |........|@. .....|
|000010e0| 00 01 00 00 00 00 00 10 | 00 08 00 00 00 00 00 02 |........|........|
|000010f0| 00 00 00 24 01 59 02 52 | 01 71 02 7a 00 03 00 00 |...$.Y.R|.q.z....|
|00001100| 00 00 00 00 00 02 01 42 | 01 65 02 6e 01 65 02 5e |.......B|.e.n.e.^|
|00001110| 00 0a 00 04 00 01 01 18 | 00 02 00 00 00 24 01 63 |........|.....$.c|
|00001120| 02 59 01 67 02 65 00 03 | 00 00 00 00 00 00 00 03 |.Y.g.e..|........|
|00001130| 01 07 01 65 02 63 01 65 | 02 5b 00 0a 00 04 00 00 |...e.c.e|.[......|
|00001140| 01 44 00 06 00 00 00 42 | 01 5c 02 1f 01 6e 02 49 |.D.....B|.\...n.I|
|00001150| 00 03 ff ff ff ff ff ff | 00 01 01 59 04 62 61 63 |........|...Y.bac|
|00001160| 6b 74 20 45 6e 64 61 73 | 65 20 54 72 61 69 6e 69 |kt Endas|e Traini|
|00001170| 6e 67 ec 40 00 75 e1 02 | 00 37 e6 70 00 75 40 0c |ng.@.u..|.7.p.u@.|
|00001180| 9b 03 00 01 4d a5 00 00 | 00 10 00 08 00 00 00 00 |....M...|........|
|00001190| 00 02 00 00 00 24 01 59 | 02 1e 01 71 02 48 00 03 |.....$.Y|...q.H..|
|000011a0| 00 00 00 00 00 00 00 02 | 01 42 01 65 02 3c 01 65 |........|.B.e.<.e|
|000011b0| 02 2a 00 0a 00 04 01 00 | 01 18 00 02 00 00 00 24 |.*......|.......$|
|000011c0| 01 63 02 32 01 67 02 3e | 00 03 00 00 00 00 00 00 |.c.2.g.>|........|
|000011d0| 00 03 01 42 01 65 02 3c | 01 65 02 34 00 0a 00 04 |...B.e.<|.e.4....|
|000011e0| 00 00 01 18 00 01 00 00 | 00 24 01 31 02 1b 01 44 |........|.$.1...D|
|000011f0| 02 7e 00 02 02 41 ab 54 | ea ff 00 01 01 32 00 14 |.~...A.T|.....2..|
|00001200| 01 00 00 0a 00 00 00 00 | 00 00 00 01 01 42 00 08 |........|.....B..|
|00001210| 00 00 00 08 46 6f 72 6d | 75 6c 61 73 00 00 00 00 |....Form|ulas....|
|00001220| 00 00 00 00 00 14 3a 43 | 65 6c 6c 2d 62 61 73 65 |......:C|ell-base|
|00001230| 64 20 46 6f 72 6d 75 6c | 61 73 00 00 00 04 4d a5 |d Formul|as....M.|
|00001240| 41 11 00 00 00 40 00 03 | 00 03 06 47 65 6e 65 76 |A....@..|...Genev|
|00001250| 61 00 00 00 00 00 07 43 | 68 69 63 61 67 6f 00 14 |a......C|hicago..|
|00001260| 00 14 05 54 69 6d 65 73 | 00 16 00 16 07 43 6f 75 |...Times|.....Cou|
|00001270| 72 69 65 72 37 47 00 0d | 0d 5a 61 70 66 20 44 69 |rier7G..|.Zapf Di|
|00001280| 6e 67 62 61 74 73 00 00 | 01 00 00 00 11 86 00 00 |ngbats..|........|
|00001290| 10 86 00 00 00 c2 00 38 | f6 ac 0a a8 00 00 00 1c |.......8|........|
|000012a0| 00 c2 00 06 50 49 4e 46 | 00 00 00 3a 44 53 54 41 |....PINF|...:DSTA|
|000012b0| 00 00 00 46 53 4f 42 4a | 00 01 00 52 53 48 41 50 |...FSOBJ|...RSHAP|
|000012c0| 00 01 00 6a 43 45 58 54 | 00 00 00 82 53 4c 53 54 |...jCEXT|....SLST|
|000012d0| 00 00 00 8e 46 54 42 4c | 00 00 00 9a 00 80 ff ff |....FTBL|........|
|000012e0| 00 00 00 00 00 00 00 00 | 00 80 ff ff 00 00 00 7c |........|.......||
|000012f0| 00 00 00 00 4d a5 ff ff | 20 00 00 aa 00 00 00 00 |....M...| .......|
|00001300| 41 11 ff ff 20 00 07 f8 | 00 00 00 00 4d a5 ff ff |A... ...|....M...|
|00001310| 20 00 02 b2 00 00 00 00 | 41 11 ff ff 20 00 0a 00 | .......|A... ...|
|00001320| 00 00 00 00 41 11 ff ff | 20 00 10 22 00 00 00 00 |....A...| .."....|
|00001330| 00 80 ff ff 00 00 10 3a | 00 00 00 00 00 80 ff ff |.......:|........|
|00001340| 00 00 10 42 00 00 00 00 | 00 00 00 00 00 00 00 00 |...B....|........|
|00001350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+